Adding or editing a charge tier markup group definition

The charge tier markup group definition tab provides a centralized location to add, edit, and delete definitions Axiom uses to reverse engineer the original cost of an item based on the markup percentages or multiplier applied by your organization's purchasing department.

To add or edit a charge tier markup group definition

  1. From the Enterprise Decision Support home page, in the Cost Accounting section, select Modify a cost model or Create a cost model.

  2. Under the Methods section, select Define markup group definitions.

  3. Select the Charge tier markup tab.

  4. If there is not an existing markup group definition table version assigned to this cost model, the table will be empty.

    1. Select the link in the "Create or select a version here" text within the table.

    2. In the Modify a cost model dialog, from the Cost method exclusion drop-down, do one of the following, and select Save:

      • To create a new version of the cost method exclusions table, select Create new version.

      • To assign an existing version of the cost method exclusions table, select the version from the list.

  5. If there is an existing markup group definition table version assigned to this cost model, and you would like to modify it:

    1. Select the link in the cost model's name in the table's header.

    2. In the Modify a cost model dialog, from the Cost method exclusion drop-down, do one of the following, and select Save:

      • To create a new version of the cost method exclusions table, select Create new version.

      • To assign an existing version of the cost method exclusions table, select the version from the list.

    NOTE: Steps 4-5 are optional. As part of the initial set up of the cost model, the version has likely already been created or selected. This step simply provides you a quick and easy way to select another version to use or create a new one from scratch, if needed.

  6. To show or hide inactive definitions in the table, select the gear icon in the upper-right portion of the screen, and check/uncheck the Show only active definitions check box. While unchecked, the table shows inactive definitions shaded in yellow. Only active definitions include a check mark in the Active column.

  7. To create or select an existing markup group definition table version to assign to this cost model, select the link in the cost model's name in the table's header. In the Modify a cost model dialog, from the Markup drop-down located at the bottom of the page, do one of the following, and select Save:

    • To create a new version of the allocation definition table, select Create new version.

    • To assign an existing version of the allocation definition table, select the version from the list.

      NOTE: This step is optional. As part of the initial set up of the cost model, the version has likely already been created or selected. This step simply provides you a quick and easy way to select another version to use or create a new one from scratch, if needed.

  8. Do one of the following:
    • To add a definition above the table, select + Add definition.

    • To edit an account, in the Actions column of the account to edit, select the notepad icon .

      TIP: To search for a specific definition, use the Search field.

  9. In the Add/Edit markup group definition dialog, complete the following:

    Field Description
    Title* Enter a name or title for the definition.
    Description Enter the details for the definition.
    Activate?

    Do one of the following:

    • To activate the definition for cost model processing, toggle to Yes.
    • To deactivate the definition so that it is not processed with the cost model, toggle to No.

    NOTE: When you create a new definition, the system activates it by default.
    Markup type

    Select one of the following:

    • Markup - Apply markup amounts based on percentage and/or a fixed amount.
    • Multiplier - Apply markup amounts using a multiplying factor.

    NOTE: You can only select this option when creating a new definition. When you edit a definition, this information is read-only.
    Department*

    Enter the department number in which to apply the definition.

    NOTE: The system excludes any department already assigned to the current mark group definition version.
    Cost category*

    Select the cost category in which to apply the definition.

    Cost categories will not display under the following conditions:

    • If the cost category is not included within the version of the dimension tables for the cost model.

    • If the cost category and department combination already exists in an existing definition.
    Range minimum

    Displays the minimum amount the item must meet to qualify for the tier level.

    This amount is determined by the amount entered in the Range maximum column from the preceding tier row. For example, if you enter 299.99 in Tier 2, the range minimum would display 300 for Tier 3.
    Range maximum Enter the maximum amount to define the tier price range.
    Markup factor

    Enter the percentage or multiplier markup to apply to the items that fall within the tier price range.
    + Fixed Amount

    Enter an amount to add in addition to the percentage or multiplier markup. This step is optional.
  10. Do any of the following, as needed:
    • To add more tiers, select + Add tier at the bottom of the table.

    • To delete a row, select the trash bin icon in the Action column. At the Confirm delete markup tier prompt, select OK.

  11. After making your changes, select Save.
  12. If you are creating a new model, the next step is to maintain RVUs. Select Next in the bottom right corner of the page.
  13. If you are modifying an existing cost model, you can continue making changes to other parts of the model, or go directly to processing the cost model if this is your only change.

    14. IMPORTANT: When making any changes to an existing cost model, you must reprocess it for the results to reflect the changes.